﻿<%@ Page Title="" Language="C#" MasterPageFile="~/adminpanel.master" AutoEventWireup="true" CodeFile="Product.aspx.cs" Inherits="Web_Product" %>

<%@ Register Assembly="DevExpress.Web.v10.2, Version=10.2.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
    Namespace="DevExpress.Web.ASPxRoundPanel" TagPrefix="dx" %>

<%@ Register assembly="DevExpress.Web.ASPxGridView.v10.2, Version=10.2.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxGridView" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.ASPxEditors.v10.2, Version=10.2.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxEditors" tagprefix="dx" %>

<%@ Register assembly="DevExpress.Web.v10.2, Version=10.2.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxUploadControl" tagprefix="dx" %>

<%@ Register assembly="DevExpress.Web.v10.2, Version=10.2.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxPanel" tagprefix="dx" %>



<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">
    
        
          
    <script src="Scripts/jquery-1.3.2.js" type="text/javascript"></script>
    <script src="Scripts/jquery.MultiFile.js" type="text/javascript"></script>

  
    
    <style type="text/css">
        .style2
        {
            width: 20px;
            height: 18px;
        }
        .style3
        {
            width: 184px;
        }
        .style5
        {
            width: 326px;
        }
        .style6
        {
            width: 324px;
        }
        .style10
        {
            width: 137px;
        }
        .style11
        {
            width: 34px;
        }
        .style12
        {
            width: 735px;
        }
        .style13
        {
            width: 245px;
        }
        .style14
        {
            width: 129px;
        }
        .style15
        {
            width: 258px;
        }
        .style22
        {
            width: 135px;
        }
        </style>

  
    
  </asp:Content>
 
 <%--Content Start--%>    
    <asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">

        <%--panel content--%>  
        <table border="0" width="100%">
            <tr>
                <td  bgcolor="#F8F8F8" >
                    &nbsp;</td>
                <td  bgcolor="#F8F8F8"  >
                    &nbsp;</td>
                <td bgcolor="#F8F8F8" width="1045" >
                    &nbsp;</td>
            </tr>
            <tr>
                <td bgcolor="#F8F8F8" colspan="3" >
                    <table width="100%" >
                        <tr>
                            <td class="style11" >
                                &nbsp;</td>
                            <td class="style13"  >
                    <asp:Label ID="Label5" runat="server" ForeColor="#0000CC" 
                        Text="Click this button to add new product" style="font-size: small"></asp:Label>
                            </td>
                            <td>
    <dx:ASPxButton ID="ASPxButton1" runat="server" ClientIDMode="AutoID"  
        CssFilePath="~/App_Themes/Office2003Olive/{0}/styles.css" CssPostfix="Office2003Olive" 
        onclick="ASPxButton1_Click" SpriteCssFilePath="~/App_Themes/Office2003Olive/{0}/sprite.css" 
        Text="Add Product" style="margin-left: 0px">
    </dx:ASPxButton>
     
        
                            </td>
                            <td>
                                &nbsp;</td>
                            <td>
                                &nbsp;</td>
                            <td>
                                &nbsp;</td>
                            <td>
                                &nbsp;</td>
                        </tr>
                        <tr>
                            <td class="style11" >
                                &nbsp;</td>
                            <td class="style13"  >
                                &nbsp;</td>
                            <td>
                                &nbsp;</td>
                            <td>
                                &nbsp;</td>
                            <td>
                                &nbsp;</td>
                            <td>
                                &nbsp;</td>
                            <td>
                                &nbsp;</td>
                        </tr>
                    </table>
                </td>
            </tr>
        </table>
     
        
    <dx:ASPxPanel ID="ASPxPanel1" runat="server" Width="100%" Height="447px" >

    <%--panel content--%>
    <%--End of panel content--%>

<Border BorderColor="#999999" BorderStyle="Solid"></Border>

        <PanelCollection>
        <dx:PanelContent runat="server" SupportsDisabledAttribute="True">
            &nbsp;<table  width="100%">
                <tr>
                    <td class="style5"  >
                        &nbsp;</td>
                    <td class="style3" >
                        <strong>
                        <asp:Label ID="Label4" runat="server" Text="Category Name" Width="100px"></asp:Label>
                        </strong></td>
                    <td >
                        &nbsp;</td>
                    <td class="style14">
                        <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" 
                            DataSourceID="SqlDataSource10" DataTextField="Cat_Name" 
                            DataValueField="Cat_Name">
                        </asp:DropDownList>
                    </td>
                    <td class="style15" >
                        &nbsp;</td>
                    <td >
                        &nbsp;</td>
                    <td >
                      <a href="Product.aspx">  <img alt="" class="style2" 
                            src="images/Delete-icon.png" /></a>
                    </td>
                    <td >
                        &nbsp;</td>
                </tr>
                <tr>
                    <td class="style5">
                        &nbsp;</td>
                    <td class="style3">
                        <strong>Subcategory ID</strong></td>
                    <td>
                        &nbsp;</td>
                    <td class="style14">
                        <asp:DropDownList ID="DropDownList2" runat="server" 
                            DataSourceID="SqlDataSource2" DataTextField="Sub_Cat_Name" 
                            DataValueField="Sub_Cat_Name">
                        </asp:DropDownList>
                    </td>
                    <td class="style15">
                    </td>
                    <td>
                    </td>
                    <td>
                    </td>
                    <td>
                    </td>
                </tr>
                <tr>
                    <td colspan="7" ><hr class="style12" />
                        </td>
                </tr>
                <tr>
                <td class="style5" >
                    &nbsp;</td>
                    <td class="style3" >
                        <strong>Product ID</strong></td>
                <td >
                    &nbsp;</td>
                    <td class="style14">
                        <dx:ASPxTextBox ID="Productid" runat="server" ClientIDMode="AutoID" 
                            CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" CssPostfix="BlackGlass" 
                            SpriteCssFilePath="~/App_Themes/BlackGlass/{0}/sprite.css" Width="150px">
                            <ValidationSettings>
                                <ErrorFrameStyle ImageSpacing="4px">
                                    <ErrorTextPaddings PaddingLeft="4px" />
                                </ErrorFrameStyle>
                                <RequiredField ErrorText="Please fill this feild" IsRequired="True" />
                            </ValidationSettings>
                        </dx:ASPxTextBox>
                    </td>
                    <td class="style15" >
                        <strong>Product Price</strong></td>
                <td >
                    <dx:ASPxTextBox ID="productprice" runat="server" ClientIDMode="AutoID" 
                        Width="150px" DisplayFormatString="Rs.{0}">
                        <MaskSettings IncludeLiterals="DecimalSymbol" 
                            Mask="&lt;0..99999g&gt;.&lt;00..99&gt;" />
                        <ValidationSettings>
                            <RequiredField ErrorText="Please fill this field" IsRequired="True" />
<RequiredField IsRequired="True" ErrorText="Please Fill this field"></RequiredField>
                        </ValidationSettings>
                    </dx:ASPxTextBox>
                </td>
                    <td >
                        &nbsp;</td>
                    <td>
                        &nbsp;</td>
            </tr>
            <tr>
                <td class="style5"  >
                    &nbsp;</td>
                <td class="style3" >
                    <strong>Product Code</strong></td>
                <td >
                    &nbsp;</td>
                <td class="style14">
                    <dx:ASPxComboBox ID="ASPxComboBox1" runat="server" ClientIDMode="AutoID" 
                        CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" CssPostfix="BlackGlass" 
                        SelectedIndex="0" SpriteCssFilePath="~/App_Themes/BlackGlass/{0}/sprite.css" 
                        ValueType="System.String" Width="150px">
                        <Items>
                            <dx:ListEditItem Selected="True" Text="A" Value="A" />
                            <dx:ListEditItem Text="B" Value="B" />
                        </Items>
                        <LoadingPanelImage Url="~/App_Themes/BlackGlass/Editors/Loading.gif">
                        </LoadingPanelImage>
                        <ButtonStyle Width="11px">
                        </ButtonStyle>
                        <ValidationSettings ErrorText="Error has occurred">
                            <ErrorFrameStyle ImageSpacing="4px">
                                <ErrorTextPaddings PaddingLeft="4px" />
                            </ErrorFrameStyle>
                            <RequiredField ErrorText="Please fill this field" IsRequired="True" />
                        </ValidationSettings>
                    </dx:ASPxComboBox>
                </td>
                <td class="style15" >
                    <strong>Purchase Price</strong></td>
                <td >
                    <dx:ASPxTextBox ID="purchaseprice" runat="server" ClientIDMode="AutoID" 
                        Width="150px" DisplayFormatString="Rs.{0}">
                        <MaskSettings Mask="&lt;0..99999g&gt;.&lt;00..99&gt;" />
                        <ValidationSettings>
                            <RequiredField ErrorText="Please fill this field" IsRequired="True" />
<RequiredField IsRequired="True" ErrorText="Please Fill this field"></RequiredField>
                        </ValidationSettings>
                    </dx:ASPxTextBox>
                </td>
                <td >
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style5" >
                    &nbsp;</td>
                <td class="style3" >
                    <strong>Product Description</strong></td>
                <td >
                    &nbsp;</td>
                <td class="style14">
                    <dx:ASPxTextBox ID="productdescription" runat="server" ClientIDMode="AutoID" 
                        CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" CssPostfix="BlackGlass" 
                        SpriteCssFilePath="~/App_Themes/BlackGlass/{0}/sprite.css" Width="150px">
                        <ValidationSettings>
                            <ErrorFrameStyle ImageSpacing="4px">
                                <ErrorTextPaddings PaddingLeft="4px" />
                            </ErrorFrameStyle>
                        </ValidationSettings>
                    </dx:ASPxTextBox>
                </td>
                <td class="style15">
                    <strong>Retail Price</strong></td>
                <td>
                    <dx:ASPxTextBox ID="retailprice" runat="server" ClientIDMode="AutoID" 
                        Width="150px" DisplayFormatString="Rs.{0}">
                        <MaskSettings Mask="&lt;0..99999g&gt;.&lt;00..99&gt;" />
                        <ValidationSettings>
                            <RequiredField ErrorText="Please fill this field" IsRequired="True" />
<RequiredField IsRequired="True" ErrorText="Please Fill this field"></RequiredField>
                        </ValidationSettings>
                    </dx:ASPxTextBox>
                </td>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style5" >
                    &nbsp;</td>
                <td class="style3">
                    <strong>Product Name</strong></td>
                <td>
                    &nbsp;</td>
                <td class="style14">
                    <dx:ASPxTextBox ID="productname" runat="server" ClientIDMode="AutoID" 
                        CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" CssPostfix="BlackGlass" 
                        SpriteCssFilePath="~/App_Themes/BlackGlass/{0}/sprite.css" Width="150px">
                        <ValidationSettings>
                            <ErrorFrameStyle ImageSpacing="4px">
                                <ErrorTextPaddings PaddingLeft="4px" />
                            </ErrorFrameStyle>
                            <RequiredField ErrorText="Please fill this field" IsRequired="True" />
                        </ValidationSettings>
                    </dx:ASPxTextBox>
                </td>
                <td class="style15">
                    <strong>Product Type</strong></td>
                <td>
                    <dx:ASPxTextBox ID="producttype" runat="server" ClientIDMode="AutoID" 
                        CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" CssPostfix="BlackGlass" 
                        SpriteCssFilePath="~/App_Themes/BlackGlass/{0}/sprite.css" Width="150px">
                        <ValidationSettings>
                            <ErrorFrameStyle ImageSpacing="4px">
                                <ErrorTextPaddings PaddingLeft="4px" />
<ErrorTextPaddings PaddingLeft="4px"></ErrorTextPaddings>
                            </ErrorFrameStyle>
                            <RequiredField ErrorText="Please fill this field" IsRequired="True"/>

<RequiredField IsRequired="True" ErrorText="Please Fill this field"></RequiredField>
                        </ValidationSettings>
                    </dx:ASPxTextBox>
                </td>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
                <tr>
                    <td colspan="7"><hr class="style12" />
                        &nbsp;</td>
                </tr>
            
    </table>
    <table width="100%">
    <tr bgcolor="White">
                <td bgcolor="#F8F8F8" class="style22">
                    </td>
                <td class="style10">
                    <strong>Point Value</strong></td>
                <td class="style6">
                    <dx:ASPxTextBox ID="pointvalue" runat="server" ClientIDMode="AutoID" 
                        Width="100px" AutoPostBack="True" 
                        CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" CssPostfix="BlackGlass" 
                        SpriteCssFilePath="~/App_Themes/BlackGlass/{0}/sprite.css">
                        <MaskSettings Mask="&lt;0..99999g&gt;.&lt;00..99&gt;" />
                        <ValidationSettings>
                            <RequiredField ErrorText="Please enter Point Value to this product" 
                                IsRequired="True" />
                            <ErrorFrameStyle ImageSpacing="4px">
                                <ErrorTextPaddings PaddingLeft="4px" />
<ErrorTextPaddings PaddingLeft="4px"></ErrorTextPaddings>
                            </ErrorFrameStyle>

<RequiredField ErrorText="Please Enter Point Value to this Product"></RequiredField>
                        </ValidationSettings>
                    </dx:ASPxTextBox>
                </td>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
                <tr>
                    <td bgcolor="#F8F8F8" class="style22">
                        &nbsp;</td>
                    <td class="style10" >
                        <strong>
                        <dx:ASPxLabel ID="ASPxLabel1" runat="server" ClientIDMode="AutoID" 
                            style="font-weight: 700" Text="Business Value" Visible="False">
                        </dx:ASPxLabel>
                        </strong></td>
                    <td class="style6" >
                        <dx:ASPxTextBox ID="businesspoint" runat="server" BackColor="#D8E3B6" 
                            ClientIDMode="AutoID" CssFilePath="~/App_Themes/Aqua/{0}/styles.css" 
                            CssPostfix="Aqua" ReadOnly="True" 
                            SpriteCssFilePath="~/App_Themes/Aqua/{0}/sprite.css" Visible="False" 
                            Width="75px">
                            <MaskSettings Mask="&lt;0..99999g&gt;.&lt;00..99&gt;" />
                            <ValidationSettings>
                                <ErrorFrameStyle ImageSpacing="4px">
                                    <ErrorTextPaddings PaddingLeft="4px" />
<ErrorTextPaddings PaddingLeft="4px"></ErrorTextPaddings>
                                </ErrorFrameStyle>
                            </ValidationSettings>
                        </dx:ASPxTextBox>
                    </td>
                    <td >
                        &nbsp;</td>
                    <td >
                        &nbsp;</td>
                    <td >
                        &nbsp;</td>
                    <td >
                        &nbsp;</td>
                </tr>
                <tr>
                    <td  bgcolor="#F8F8F8" class="style22">
                        &nbsp;</td>
                    <td class="style10">
                        <strong>Product image</strong></td>
                    <td  colspan="2">
                        <strong>
                        <asp:FileUpload ID="FileUpload1" runat="server" class="multi" Width="200px" />
                        </strong>
                    </td>
                    <td>
                        &nbsp;</td>
                    <td >
                        &nbsp;</td>
                    <td >
                        &nbsp;</td>
                </tr>
                <tr>
                    <td  bgcolor="#F8F8F8" class="style22">
                        &nbsp;</td>
                    <td class="style10" >
                        <strong></strong></td>
                    <td  colspan="2">
                        <asp:Label ID="Label2" runat="server" Text="Label" Visible="False"></asp:Label>
                    </td>
                    <td >
                        &nbsp;</td>
                    <td >
                        &nbsp;</td>
                    <td >
                        &nbsp;</td>
                </tr>
            <tr>
                <td  bgcolor="#F8F8F8" class="style22">
                    &nbsp;</td>
                <td class="style10" >
                    &nbsp;</td>
                <td  colspan="2">
                <dx:ASPxButton ID="ASPxButton2" runat="server" ClientIDMode="AutoID" 
                    CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" CssPostfix="BlackGlass" 
                    OnClick="ASPxButton2_Click" 
                    SpriteCssFilePath="~/App_Themes/BlackGlass/{0}/sprite.css" 
                    Text="Add New Product">
                    </dx:ASPxButton>
                </td>
                <td>
                    <dx:ASPxButton ID="ASPxButton3" runat="server" ClientIDMode="AutoID" 
                        CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" CssPostfix="BlackGlass" 
                        Height="23px" OnClick="ASPxButton3_Click" 
                        SpriteCssFilePath="~/App_Themes/BlackGlass/{0}/sprite.css" Text="Cancel" 
                        Width="78px">
                    </dx:ASPxButton>
                </td>
                <td>
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td bgcolor="#F8F8F8" class="style22">
                    &nbsp;</td>
                <td class="style10">
                    <strong></strong></td>
                <td colspan="2">
                    <strong>
                    <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
                        ConnectionString="<%$ ConnectionStrings:BestlifeDBConnectionString %>" 
                        SelectCommand="SELECT [Sub_Cat_Name] FROM [Tbl_Sub_Category] WHERE ([Cat_Name] = @Cat_Name)">
                        <SelectParameters>
                            <asp:ControlParameter ControlID="DropDownList1" Name="Cat_Name" 
                                PropertyName="SelectedValue" Type="String" />
                        </SelectParameters>
                    </asp:SqlDataSource>
                    </strong></td>
                <td >
                    &nbsp;</td>
                <td >
                    &nbsp;</td>
                <td>
                    <asp:SqlDataSource ID="SqlDataSource10" runat="server" 
                        ConnectionString="<%$ ConnectionStrings:BestlifeDBConnectionString %>" 
                        SelectCommand="SELECT [Cat_Name] FROM [Tbl_Category]"></asp:SqlDataSource>
                </td>
            </tr></table>
            </dx:PanelContent>
            
</PanelCollection>

        <Border BorderColor="#999999" BorderStyle="Solid" />

    </dx:ASPxPanel>

        <asp:Label ID="Label3" runat="server" Text="Label" Visible="False"></asp:Label>
    <br />
     

    <dx:ASPxGridView ID="ASPxGridView1" runat="server" AutoGenerateColumns="False" 
        ClientIDMode="AutoID" DataSourceID="SqlDataSource1" KeyFieldName="Pro_ID;Code" Width="100%" 
        onrowupdating="ASPxGridView1_RowUpdating" CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" 
        CssPostfix="BlackGlass" onrowvalidating="ASPxGridView1_RowValidating" 
            oncustomunboundcolumndata="ASPxGridView1_CustomUnboundColumnData" 
            onload="ASPxGridView1_Load" >
        
        <%--Start of columns--%>
        <Columns>
           <dx:GridViewCommandColumn VisibleIndex="0" FixedStyle="Left" CellStyle-BackColor="#ffffd6" Width="25">
                <EditButton Visible="True">
                </EditButton>
                <ClearFilterButton Visible="True">
                </ClearFilterButton>
                <HeaderStyle Font-Bold="True" ForeColor="Black" />
                <CellStyle BackColor="#DEE1E7" Font-Bold="True" ForeColor="Black"></CellStyle>
           </dx:GridViewCommandColumn>

           <dx:GridViewCommandColumn VisibleIndex="1" FixedStyle="Left" 
                 CellStyle-BackColor="#ffffd6" Width="50">
                <DeleteButton Visible="True">
                </DeleteButton>
                <HeaderStyle Font-Bold="True" ForeColor="Black" />
                <CellStyle BackColor="#DEE1E7" Font-Bold="True" ForeColor="Black"></CellStyle>
           </dx:GridViewCommandColumn>

           <dx:GridViewDataComboBoxColumn Caption="Category Name" FieldName="Cat_Name" 
                VisibleIndex="2" Width="100px">
                <PropertiesComboBox TextField="Cat_Name" ValueField="Cat_Name" EnableSynchronization="True"
                    IncrementalFilteringMode="StartsWith" DataSourceID="SqlDataSource7" >
                </PropertiesComboBox>
           </dx:GridViewDataComboBoxColumn>

            <dx:GridViewDataComboBoxColumn Caption="Sub Category Name" FieldName="Sub_Cat_Name" 
                VisibleIndex="3" Width="100px">
                 <PropertiesComboBox TextField="Sub_Cat_Name" ValueField="Sub_Cat_Name" EnableSynchronization="False"
                    IncrementalFilteringMode="StartsWith" DataSourceID="SqlDataSource8">
                 </PropertiesComboBox>
            </dx:GridViewDataComboBoxColumn>

            <dx:GridViewDataTextColumn FieldName="Pro_ID"  VisibleIndex="4" Width="100px"
                Caption="Product ID" ShowInCustomizationForm="True">
            </dx:GridViewDataTextColumn>

            <dx:GridViewDataComboBoxColumn Caption="Product Code" FieldName="Code" 
                 VisibleIndex="5" Width="100px">
                <PropertiesComboBox ValueType="System.String" EnableSynchronization="False" IncrementalFilteringMode="StartsWith" >
                    <Items>
                        <dx:ListEditItem Text="A" Value="1"  />
                        <dx:ListEditItem Text="B" Value="2" />
                    </Items>
                    <ItemStyle Cursor="auto" />
                </PropertiesComboBox>
            </dx:GridViewDataComboBoxColumn>

            <dx:GridViewDataTextColumn FieldName="Pro_Name" VisibleIndex="6" 
                Caption="Product Name" Width="100px" ShowInCustomizationForm="True">
            </dx:GridViewDataTextColumn>

            <dx:GridViewDataTextColumn FieldName="Description" VisibleIndex="6" 
                Caption="Product Description" Width="100px" ShowInCustomizationForm="True">
            </dx:GridViewDataTextColumn>

          

            <dx:GridViewDataTextColumn FieldName="Pro_Price" VisibleIndex="8" 
                Caption="Product Price" Width="100px" ShowInCustomizationForm="True">
                <PropertiesTextEdit DisplayFormatString="Rs.{0}">
                    <MaskSettings IncludeLiterals="DecimalSymbol" 
                        Mask="&lt;0..99999g&gt;.&lt;00..99&gt;" />
                    <ValidationSettings>
                        <RegularExpression ErrorText="" />
                        <RequiredField ErrorText="" />
                    </ValidationSettings>
                </PropertiesTextEdit>
            </dx:GridViewDataTextColumn>

            <dx:GridViewDataTextColumn FieldName="Ret_Price" VisibleIndex="10"
                Caption="Retail Price" Width="100px" ShowInCustomizationForm="True" >
                <PropertiesTextEdit DisplayFormatString="Rs.{0}" >
                    <MaskSettings IncludeLiterals="DecimalSymbol" 
                        Mask="&lt;0..99999g&gt;.&lt;00..99&gt;" />
                </PropertiesTextEdit>
            </dx:GridViewDataTextColumn>

            <dx:GridViewDataTextColumn FieldName="Pur_Price" VisibleIndex="11"
                Caption="Purchase Price" Width="100px" ShowInCustomizationForm="True">
                <PropertiesTextEdit DisplayFormatString="Rs.{0}">
                    <MaskSettings IncludeLiterals="DecimalSymbol" 
                        Mask="&lt;0..99999g&gt;.&lt;00..99&gt;" />
                </PropertiesTextEdit>
                <PropertiesTextEdit >
                </PropertiesTextEdit>
            </dx:GridViewDataTextColumn>

            <dx:GridViewDataTextColumn FieldName="Point_Value" VisibleIndex="12" 
                Caption="Point Value">
                <PropertiesTextEdit>
                    <MaskSettings IncludeLiterals="DecimalSymbol" 
                        Mask="&lt;0..99999g&gt;.&lt;00..99&gt;" />
                </PropertiesTextEdit>
            </dx:GridViewDataTextColumn>
            
            <dx:GridViewDataTextColumn FieldName="Percentage" VisibleIndex="13" 
                 Visible="False">
                <PropertiesTextEdit>
                    <MaskSettings IncludeLiterals="DecimalSymbol" Mask="&lt;0..100&gt;" />
                </PropertiesTextEdit>
                <EditFormSettings Visible="True" VisibleIndex="13" />
            </dx:GridViewDataTextColumn>
           

            <dx:GridViewDataTextColumn Caption="Business Value" FieldName="Business_Value" 
                  UnboundType="Decimal" VisibleIndex="14" Width="100px" ReadOnly="True" >
                 <PropertiesTextEdit  >
                     <MaskSettings IncludeLiterals="DecimalSymbol" 
                         Mask="&lt;0..99999g&gt;.&lt;00..99&gt;" />
                 </PropertiesTextEdit>
                 <EditCellStyle BackColor="#FAE4A3" ForeColor="#FEE7A5">
                 </EditCellStyle>
                 <EditFormCaptionStyle BackColor="#F0DA9C">
                 </EditFormCaptionStyle>
             </dx:GridViewDataTextColumn>

           
            <dx:GridViewDataTextColumn FieldName="Pro_Image" VisibleIndex="15" 
                Caption="Product image">
                
            </dx:GridViewDataTextColumn>
            <dx:GridViewDataTextColumn Caption="Product image" FieldName="Pro_Image2" 
                 ShowInCustomizationForm="True" VisibleIndex="16">
            </dx:GridViewDataTextColumn>
            <dx:GridViewDataTextColumn Caption="Product image" FieldName="Pro_Image3" 
                 ShowInCustomizationForm="True" VisibleIndex="17">
            </dx:GridViewDataTextColumn>
            <dx:GridViewDataTextColumn Caption="Product image" FieldName="Pro_Image4" 
                 ShowInCustomizationForm="True" VisibleIndex="18">
            </dx:GridViewDataTextColumn>
           
 </Columns>
        <%--End of columns--%>

        <SettingsBehavior ConfirmDelete="True" />
        <Settings ShowHorizontalScrollBar="True" ShowFilterRow="True" />
        <Images SpriteCssFilePath="~/App_Themes/BlackGlass/{0}/sprite.css">
            <LoadingPanelOnStatusBar Url="~/App_Themes/BlackGlass/GridView/gvLoadingOnStatusBar.gif">
            </LoadingPanelOnStatusBar>
            <LoadingPanel Url="~/App_Themes/BlackGlass/GridView/Loading.gif">
            </LoadingPanel>
        </Images>
        <ImagesFilterControl>
            <LoadingPanel Url="~/App_Themes/BlackGlass/Editors/Loading.gif">
            </LoadingPanel>
        </ImagesFilterControl>
        <Styles CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" 
            CssPostfix="BlackGlass">
            <Header ImageSpacing="5px" SortingImageSpacing="5px">
            </Header>
        </Styles>
        <StylesEditors>
            <CalendarHeader Spacing="1px">
            </CalendarHeader>
            <ProgressBar Height="25px">
            </ProgressBar>
        </StylesEditors>

  </dx:ASPxGridView>
       
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:BestlifeDBConnectionString %>" 
        SelectCommand="SELECT [Pro_ID], [Code], [Description], [Pro_Name], [Pro_Price], [Ret_Price], [Pur_Price], [Point_Value],[Pro_Image], [Pro_Image2], [Pro_Image3], [Pro_Image4], [Cat_Name], [Sub_Cat_Name], [Percentage], [Business_Value] FROM [Tbl_Product]" 
        InsertCommand="INSERT INTO [Tbl_Product] ([Pro_ID], [Code], [Description], [Pro_Name], [Pro_Price], [Ret_Price], [Pur_Price], [Point_Value],[Pro_Image], [Pro_Image2], [Pro_Image3], [Pro_Image4], [Cat_Name], [Sub_Cat_Name], [Percentage], [Business_Value]) VALUES (@Pro_ID, @Code, @Description, @Pro_Name, @Pro_Price, @Ret_Price, @Pur_Price, @Point_Value,@Pro_Image, @Pro_Image2, @Pro_Image3, @Pro_Image4, @Cat_Name, @Sub_Cat_Name, @Percentage, @Business_Value)" 
        DeleteCommand="DELETE FROM [Tbl_Product] WHERE [Pro_ID] = @Pro_ID AND [Code] = @Code" 
        UpdateCommand="UPDATE [Tbl_Product] SET [Description] = @Description, [Pro_Name] = @Pro_Name, [Pro_Price] = @Pro_Price, [Ret_Price] = @Ret_Price, [Pur_Price] = @Pur_Price, [Point_Value] = @Point_Value, [Pro_Image] = @Pro_Image, [Pro_Image2] = @Pro_Image2, [Pro_Image3] = @Pro_Image3, [Pro_Image4] = @Pro_Image4, [Cat_Name] = @Cat_Name, [Sub_Cat_Name] = @Sub_Cat_Name, [Percentage] = @Percentage, [Business_Value] = @Business_Value WHERE [Pro_ID] = @Pro_ID AND [Code] = @Code"
        >
        <DeleteParameters>
            
             <asp:Parameter Name="Pro_ID" Type="String" />
             <asp:Parameter Name="Code" Type="String" />
        </DeleteParameters>
        <InsertParameters>
            <asp:Parameter Name="Pro_ID" Type="String" />
             <asp:Parameter Name="Code" Type="String" />
              <asp:Parameter Name="Description" Type="String" />
               <asp:Parameter Name="Pro_Name" Type="String" />
                <asp:Parameter Name="Pro_Price" Type="Decimal" />
                 <asp:Parameter Name="Ret_Price" Type="Decimal" />
                  <asp:Parameter Name="Pur_Price" Type="Decimal" />
                   <asp:Parameter Name="Point_Value" Type="Decimal" />
                   
                     <asp:Parameter Name="Pro_Image" Type="String" />
                      <asp:Parameter Name="Pro_Image2" Type="String" />
                       <asp:Parameter Name="Pro_Image3" Type="String" />
                        <asp:Parameter Name="Pro_Image4" Type="String" />
                         <asp:Parameter Name="Cat_Name" Type="String" />
                         <asp:Parameter Name="Sub_Cat_Name" Type="String" />

            <asp:Parameter Name="Percentage" Type="String" />
            <asp:Parameter Name="Business_Value" Type="Decimal" />

        </InsertParameters>

        <UpdateParameters>
            <asp:Parameter Name="Description" Type="String" />
             <asp:Parameter Name="Pro_Name" Type="String" />
              <asp:Parameter Name="Pro_Price" Type="Decimal" />
               <asp:Parameter Name="Ret_Price" Type="Decimal" />
                <asp:Parameter Name="Pur_Price" Type="Decimal" />
                 <asp:Parameter Name="Point_Value" Type="Decimal" />
                  
                   <asp:Parameter Name="Pro_Image" Type="String" />
                    <asp:Parameter Name="Pro_Image2" Type="String" />
                     <asp:Parameter Name="Pro_Image3" Type="String" />
                      <asp:Parameter Name="Pro_Image4" Type="String" />
                       <asp:Parameter Name="Cat_Name" Type="String" />
                        <asp:Parameter Name="Sub_Cat_Name" Type="String" />
                         <asp:Parameter Name="Percentage" Type="String" />
                         <asp:Parameter Name="Business_Value" Type="Decimal" />
            <asp:Parameter Name="Pro_ID" Type="String" />
            <asp:Parameter Name="Code" Type="String" />
        </UpdateParameters>

    </asp:SqlDataSource>

        <asp:SqlDataSource ID="SqlDataSource7" runat="server" 
            ConnectionString="<%$ ConnectionStrings:BestlifeDBConnectionString %>" 
            SelectCommand="SELECT [Cat_Name] FROM [Tbl_Category]"></asp:SqlDataSource>
        <asp:SqlDataSource ID="SqlDataSource8" runat="server" 
            ConnectionString="<%$ ConnectionStrings:BestlifeDBConnectionString %>" 
            SelectCommand="SELECT [Sub_Cat_Name] FROM [Tbl_Sub_Category]">
        </asp:SqlDataSource>

    
                <asp:SqlDataSource runat="server" 
            ConnectionString="<%$ ConnectionStrings:BestlifeDBConnectionString %>" 
            SelectCommand="SELECT [Cat_Name] FROM [Tbl_Category]" 
            ID="SqlDataSource5"></asp:SqlDataSource>

                        
    </asp:Content>
 <%--End of content--%>

